Budget Planner Expert budget creation and management agent that builds comprehensive budgets, tracks spending against plans, analyzes variances, and optimizes resource allocation. Specializes in zero-based budgeting, rolling forecasts, and multi-scenario planning. This skill applies structured budgeting methodologies to help organizations plan spending, control costs, and make data-driven allocation decisions. Perfect for annual planning, project budgets, departmental spending, and startup runway management. Core Workflows Workflow 1: Annual Budget Creation Objective: Build a comprehensive annual operating budget from scratch Steps: Gather Historical Data Prior year actuals (P&L by month) Prior year budget vs actual variances Headcount and compensation data Vendor contracts and commitments Capital expenditure history Revenue trends and projections Define Budget Parameters Fiscal year start/end dates Budget cycle (calendar vs fiscal) Currency and exchange assumptions Inflation assumptions (2-4% typical) Headcount growth assumptions Revenue growth targets Revenue Budget Product/service revenue projections Pricing assumptions Volume/unit assumptions Seasonal patterns New product launches Customer retention assumptions Geographic mix Cost of Goods Sold (COGS) Budget Direct materials costs Direct labor costs Manufacturing overhead Gross margin targets Unit economics assumptions Operating Expense Budget Personnel Costs: Salaries and wages (by department) Benefits (typically 20-30% of salary) Payroll taxes (7.65% FICA + state) Bonuses and commissions Stock-based compensation Contractor costs Facilities Costs: Rent and lease payments Utilities Insurance Maintenance and repairs Property taxes Technology Costs: Software subscriptions (SaaS) Hardware and equipment Cloud infrastructure IT support and services Marketing Costs: Advertising and media Events and conferences Content and creative Marketing technology Agency fees General & Administrative: Legal and professional services Accounting and audit Office supplies Travel and entertainment Training and development Capital Expenditure Budget Equipment purchases Facility improvements Technology infrastructure Depreciation schedules Cash Flow Implications Working capital needs CapEx timing Seasonal cash requirements Financing needs Budget Consolidation Roll up departmental budgets Eliminate intercompany items Create consolidated P&L budget Balance sheet projections Cash flow projections Scenario Development Base case (most likely) Upside case (+10-20% revenue) Downside case (-10-20% revenue) Cost reduction scenarios Deliverable: Complete annual budget package with P&L, departmental details, and scenarios Workflow 2: Project Budget Development Objective: Create a detailed budget for a specific project or initiative Steps: Project Scope Definition Project objectives and deliverables Timeline and milestones Resource requirements Success criteria Constraints and dependencies Work Breakdown Structure Decompose project into phases Identify major work packages List activities within each package Estimate effort for each activity Resource Cost Estimation Internal Labor: Identify required roles Estimate hours per role Apply fully-loaded labor rates Account for utilization rates External Resources: Contractor/consultant rates Agency or vendor costs Outsourced services Non-Labor Costs Materials and supplies Software and tools Equipment and hardware Travel and expenses Training and certifications Contingency reserve (10-20%) Cost Phasing Spread costs across timeline Account for payment terms Identify upfront vs. ongoing costs Create monthly cost forecast Budget Controls Approval thresholds Change request process Variance reporting triggers Contingency release criteria Risk-Adjusted Budget Identify cost risks Probability-weighted contingency Management reserve (if applicable) Total project budget with reserves Deliverable: Project budget with timeline, resource plan, and risk contingencies Workflow 3: Zero-Based Budgeting Objective: Build budget from scratch justifying every expense Steps: Identify Decision Units Define budget owners Establish decision units (departments, functions) Clarify accountability Define Service Levels Minimum level (survival) Current level (maintain status quo) Improvement level (enhanced performance) Each level must be costed Cost Justification For each expense, answer: Why is this needed? What happens without it? What are alternatives? What's the ROI? Decision Package Creation Package 1: Minimum viable operations Package 2: Core operations Package 3: Growth investments Package 4: Strategic initiatives Ranking and Prioritization Stack rank all packages Apply funding constraints Make trade-off decisions Document rationale Final Budget Assembly Fund packages within constraints Document unfunded priorities Create implementation plan Deliverable: Zero-based budget with prioritized decision packages Workflow 4: Rolling Forecast Update Objective: Continuously update budget with latest actuals and projections Steps: Close Period Gather actual results for completed period Ensure data completeness Reconcile to GL/accounting Variance Analysis Calculate budget vs actual variances Identify significant variances (>5% or material) Categorize as: Timing differences (will normalize) Run-rate changes (permanent) One-time items (non-recurring) Forecast Adjustment Update remaining periods based on: Run-rate from actuals Known commitments Revised assumptions New information Full-Year Outlook Combine YTD actuals + forecast Compare to original budget Calculate expected year-end variance Identify risks to forecast Action Planning If tracking above budget: investment opportunities If tracking below budget: corrective actions Document assumptions and risks Assign owners to actions Reporting Package Executive summary Variance commentary Updated forecast Risks and opportunities Recommended actions Deliverable: Updated rolling forecast with variance analysis and action plan Workflow 5: Startup Runway Planning Objective: Model cash runway and funding needs for startups Steps: Current Cash Position Cash on hand Outstanding receivables Available credit lines Expected fundraise timing Monthly Burn Rate Analysis Current monthly expenses Committed future expenses Planned hiring costs Growth investments Revenue Assumptions Current MRR/ARR Growth rate assumptions Churn assumptions Cash collection timing Runway Calculation Gross burn = Total monthly expenses Net burn = Gross burn - Revenue Runway = Cash / Net Burn Zero cash date projection Scenario Modeling Current trajectory Aggressive growth scenario Conservative/survival scenario Path to profitability scenario Milestone Mapping Key milestones for next funding round Costs to achieve milestones Timeline requirements Funding amount needed Cash Management Actions Expense reduction opportunities Revenue acceleration options Timing optimization Bridge financing options Deliverable: Runway model with scenarios and funding recommendations Quick Reference Action Command/Trigger Create annual budget "Build annual budget for [year/org]" Project budget "Create budget for [project]" Variance analysis "Analyze budget vs actual for [period]" Update forecast "Update rolling forecast with [month] actuals" Runway analysis "Calculate runway with current burn" Zero-based budget "Build ZBB for [department]" Budget Templates Monthly P&L Budget Template | Line Item | Jan | Feb | Mar | Q1 | Apr | May | Jun | Q2 | ... | FY Total | |

|

Budget Variance Report: [Period]

Executive Summary

Total Revenue: $XXX vs Budget $XXX (X% variance)

Total Expenses: $XXX vs Budget $XXX (X% variance)

Net Income: $XXX vs Budget $XXX (X% variance)

Significant Variances (>5%)

|

|

Full-Year Impact

Current trajectory vs annual budget

Risks to achieving budget

Recommended actions

Forecast Update

Revised full-year forecast

Key assumption changes Budgeting Best Practices Planning Phase Start with strategic priorities Get executive alignment on key assumptions Involve budget owners early Build in realistic timelines Document all assumptions Execution Phase Distribute budgets to owners Establish spending approval processes Set up variance monitoring Create regular reporting cadence Enable budget vs actual tracking Monitoring Phase Monthly variance reviews Rolling forecast updates Action plans for significant variances Re-forecast when major changes occur Year-end projections Common Budget Categories Category Typical % of OpEx Notes Personnel 60-70% Largest expense for most companies Technology 10-15% Growing rapidly with SaaS adoption Marketing 10-20% Varies by stage and industry Facilities 5-10% Often fixed costs G&A 5-10% Legal, accounting, insurance Integration with Other Skills Use with cash-flow-forecaster : Convert budget to cash projections Use with revenue-modeler : Develop revenue assumptions Use with unit-economics-calculator : Validate profitability assumptions Use with cost-optimizer : Identify budget reduction opportunities Use with financial-reporter : Create budget reporting packages Common Pitfalls to Avoid Hockey stick projections: Be realistic about growth rates Ignoring seasonality: Build monthly fluctuations into budget Underestimating personnel costs: Include benefits, taxes, raises Forgetting one-time costs: License renewals, annual fees No contingency: Include 5-10% buffer for unknowns Static budgets: Update forecasts as reality changes Sandbbagging: Budgets should be achievable but ambitious No accountability: Assign clear owners to every line item

budget planner

安装

|

|

|

|

|

|

|

|

|

|